package com.jack.database_exp.mapper;
import com.jack.database_exp.bean.Goods;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
import java.util.List;
public interface GoodsMapper {
    @Select("select * from goods")
    public List<Goods>  queryGoods();
    @Update("update goods set GNum=GNum+#{num} where GNo=#{id}")
    public int updateGoodsById(@Param("num") Integer num,@Param("id") Integer id);
    @Select("select * from goods where GNum < 700")
    public List<Goods> queryRemind();
}
